

module.exports = app => {
  const { STRING, CHAR, JSON,INTEGER,DATE } = app.Sequelize; // 获取数据类型

  const UserManagement = app.modelmysql.define('userManagement',
    {
      _id: {
        type:INTEGER,
        primaryKey: true,
        autoIncrement:true,
       unique:true
      },
      name: { type: STRING },
      phone: { type: STRING },
      address: { type: STRING },
      bindOnuArr: { type:JSON},
       outTime:{type:STRING},
       minTime:{type:STRING},
      tid: { type: CHAR(27) },
      groupId:{type:STRING},
      macAddress: { type:STRING},
      bandWidth:{type:STRING},
      CATV:{type:STRING},
      SN:{type:STRING},
      onuId:{type:STRING}
    }
  );
  return UserManagement;
};
